<?php
/**
 * SNS功能商品
 *
 * @网店运维提供技术支持 授权请购买shopnc授权
 * @license    http://www.shopwwi.com
 * @link       交流群号：111731672
 */
defined('ByShopWWI') or exit('Access Invalid!');
class sns_goodsModel extends Model{
    public function __construct(){
        parent::__construct('sns_goods');
    }
    /**
     * 查询SNS商品详细
     *
     * @param array $condition
     * @param string $field
     * @return array
     */
    public function getSNSGoodsInfo($condition, $field = '*'){
        $result = $this->field($field)->where($condition)->find();
        return $result;
    }
    /**
     * 新增SNS商品
     *
     * @param $param 添加信息数组
     * @return 返回结果
     */
    public function goodsAdd($param){
        if (empty($param)){
            return false;
        }
        if (is_array($param)){
            $result = Db::insert('sns_goods',$param);
            return $result;
        }else {
            return false;
        }
    }
    /**
     * 查询SNS商品详细
     *
     * @param $condition 查询条件
     * @param $field 查询字段
     */
    public function getGoodsInfo($condition,$field='*'){
        $param = array();
        $param['table'] = 'sns_goods';
        $param['field'] = array_keys($condition);
        $param['value'] = array_values($condition);
        return Db::getRow($param,$field);
    }
    /**
     * 更新SNS商品信息
     * @param $param 更新内容
     * @param $condition 更新条件
     */
    public function editGoods($param,$condition) {
        if(empty($param)) {
            return false;
        }
        //得到条件语句
        $condition_str  = $this->getCondition($condition);
        $result = Db::update('sns_goods',$param,$condition_str);
        return $result;
    }
    /**
     * 将条件数组组合为SQL语句的条件部分
     *
     * @param   array $condition_array
     * @return  string
     */
    private function getCondition($condition_array){
        $condition_sql = '';
        //商品ID
        if ($condition_array['snsgoods_goodsid'] != '') {
            $condition_sql  .= " and sns_goods.snsgoods_goodsid = '{$condition_array['snsgoods_goodsid']}'";
        }
        return $condition_sql;
    }
}
